﻿/*
=============================================================================
Author:魏宝辉通过CodeSmithe生成
CreatedTime:2012-8-14
Description:RoomList.aspx.cs页面代码
=============================================================================	
*/

using System;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;

public partial class RoomList : System.Web.UI.Page
{

    string TableName = "RoomList";//表名
    static string SqlWhere = " 1=1 ";//过滤条件
    string GetCountSql = "select count(id)  from RoomList where " + SqlWhere;
    string SqlTable = "select *  from RoomList where " + SqlWhere + "  order by id desc ";
    string ReturnPage = "RoomList.aspx";
    FTchina.SearchQuery.QueryModel qm = new FTchina.SearchQuery.QueryModel();//实例化模型

    protected void Page_Load(object sender, EventArgs e)
    {
        FTchina.basic.CheckAdmin(this);
        FTchina.basic.ChkPoewr(this, FTchina.Api.htmlpath.GetCurrentPagePath());
        if (!IsPostBack)
        {
            string act = FTchina.basic.FilterSQL(Request["act"]);
            switch (act)
            {
                case "mod":
                    {
                        btnRoomListOk.Text = "确定修改";
                        txbid.Enabled = false;
                        DisplayData();
                        plop.Visible = true;
                        break;
                    }
                case "del":
                    {
                        DeleteData();
                        break;
                    }
                case "add":
                    {
                        txbid.Text = "0";
                        txbid.Visible = false;
                        plop.Visible = true;//添加修改的表单可以看见
                        break;
                    }
                default:
                    {
                        txbid.Text = "0";
                        txbid.Visible = false;
                        plop.Visible = false;//添加修改的表单看不见
                        break;
                    }

            }

            if (qm.WorkPage != ReturnPage)
            {
                qm.TableName = TableName;
                qm.GetCountSql = GetCountSql;
                qm.GetTableSql = SqlTable;
                qm.ReturnPage = ReturnPage;
                qm.SqlWhere = SqlWhere;
                qm.WorkPage = ReturnPage;

            }

            bindData(qm);
        }
    }

    private void DeleteData()
    {
        FTchina.UImsg.PageRender(FTchina.BLL.RoomListManager.DeleteRoomListByid(Convert.ToInt32(FTchina.basic.FilterSQL(Request["id"]))) > 0, HttpContext.Current.Request.Path.ToString());
    }
    private void DisplayData()
    {
        FTchina.Models.RoomList mRoomList = FTchina.BLL.RoomListManager.GetRoomListByid(Convert.ToInt32(FTchina.basic.FilterSQL(Request["id"])));

        txbid.Text = mRoomList.Id.ToString();
        txbpcount.Text = mRoomList.Pcount.ToString();
        txbroomName.Text = mRoomList.RoomName.ToString();

        txbstate.Text = mRoomList.State.ToString();

        txbstateDate.Text = mRoomList.StateDate.ToString();

        txbcustomerID.Text = mRoomList.CustomerID.ToString();

    }

    private void DataModifiy()
    {
        FTchina.Models.RoomList mRoomList = new FTchina.Models.RoomList();

        mRoomList.Id = Convert.ToInt32(FTchina.basic.FilterSQL(txbid.Text));
        mRoomList.RoomName = FTchina.basic.FilterSQL(txbroomName.Text);
        if (mRoomList.RoomName.Trim() == "")
        {
            FTchina.JS.Alert("请输入名称");
            return;
        }
        if (txbpcount.Text.ToString().Trim() == "")
        {
            FTchina.JS.Alert("请输入容纳人数");
            return;
        }
        
        mRoomList.Pcount = Convert.ToInt32(FTchina.basic.FilterSQL(txbpcount.Text));

     

        mRoomList.State = FTchina.basic.FilterSQL(txbstate.Text);

        mRoomList.StateDate = Convert.ToDateTime(FTchina.basic.FilterSQL(txbstateDate.Text));

        mRoomList.CustomerID = FTchina.basic.FilterSQL(txbcustomerID.Text);


        FTchina.UImsg.PageRender(FTchina.BLL.RoomListManager.ModifyRoomListByid(mRoomList) > 0);

    }
    private void DataAdd()
    {
        FTchina.Models.RoomList mRoomList = new FTchina.Models.RoomList();

        mRoomList.Id = Convert.ToInt32(FTchina.basic.FilterSQL(txbid.Text));
        mRoomList.RoomName = FTchina.basic.FilterSQL(txbroomName.Text);
        if (mRoomList.RoomName.Trim() == "")
        {
            FTchina.JS.Alert("请输入名称");
            return;
        }
        if (txbpcount.Text.ToString().Trim() == "")
        {
            FTchina.JS.Alert("请输入容纳人数");
            return;
        }

        mRoomList.Pcount = Convert.ToInt32(FTchina.basic.FilterSQL(txbpcount.Text));
      

        mRoomList.State = "0";

        mRoomList.StateDate = FTchina.basic.GetStartDate();

        mRoomList.CustomerID = FTchina.basic.FilterSQL(txbcustomerID.Text);


        FTchina.UImsg.PageRender(FTchina.BLL.RoomListManager.AddRoomList(mRoomList) > 0);
    }


    protected void btnRoomListOk_Click(object sender, EventArgs e)
    {
        if (btnRoomListOk.Text == "确定修改") DataModifiy();
        else DataAdd();
    }


    #region gvList显示

    private void bindData(FTchina.SearchQuery.QueryModel qm)
    {

        int pCurrentPage = (FTchina.basic.SafeRequest(Request["page"]).Length > 0) ? Convert.ToInt32(FTchina.basic.SafeRequest(Request["page"])) : 1;
        int pageSize = 15;//每页的数据
        int AllCount = Convert.ToInt32(FTchina.shujuku.GetDataTable(qm.GetCountSql).Rows[0][0].ToString());//数据总条目数
        litpager.Text = FTchina.Api.Pager.GetPagerWithPageName(qm.GetTableSql, AllCount, pCurrentPage, pageSize, qm.ReturnPage);
        gvList.DataSource = FTchina.shujuku.ShowForPage(qm.TableName, qm.SqlWhere, pCurrentPage, pageSize);
        gvList.DataBind();

    }
    #endregion





    #region GridView等控件导出到Excel
    protected void btnexcel_Click(object sender, EventArgs e)
    {
        //将分页去除
        gvList.Width = Unit.Percentage(100);
        gvList.AutoGenerateColumns = false;
        gvList.AllowPaging = false;
        string GetDateSql = string.Format(SqlTable, TableName);
        DataSet ds = FTchina.shujuku.GetDataSet(GetDateSql);
        gvList.DataSource = ds;
        gvList.DataBind();

        System.IO.StringWriter stringWrite = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter writer = new System.Web.UI.HtmlTextWriter(stringWrite);
        gvList.RenderControl(writer);

        FTchina.Api.ToExcel.HtmlTableToExcel(stringWrite.ToString());
    }
    public override void VerifyRenderingInServerForm(Control control)
    {
        // 覆盖VerifyRenderingInServerForm方法，非常重要，否则系统会报错
        //base.VerifyRenderingInServerForm(control);
    }
    #endregion


    protected void btnFree_Click(object sender, EventArgs e)
    {
        TableName = "RoomList";//表名
        SqlWhere = " state=0 ";//过滤条件
        GetCountSql = "select count(id)  from RoomList where " + SqlWhere;
        SqlTable = "select *  from RoomList where " + SqlWhere + "  order by id desc ";
        ReturnPage = "RoomList.aspx";
        qm.TableName = TableName;
        qm.GetCountSql = GetCountSql;
        qm.GetTableSql = SqlTable;
        qm.ReturnPage = ReturnPage;
        qm.SqlWhere = SqlWhere;
        qm.WorkPage = ReturnPage;



        bindData(qm);
    }
    protected void btnWork_Click(object sender, EventArgs e)
    {
        TableName = "RoomList";//表名
        SqlWhere = " state=1 ";//过滤条件
        GetCountSql = "select count(id)  from RoomList where " + SqlWhere;
        SqlTable = "select *  from RoomList where " + SqlWhere + "  order by id desc ";
        ReturnPage = "RoomList.aspx";
        qm.TableName = TableName;
        qm.GetCountSql = GetCountSql;
        qm.GetTableSql = SqlTable;
        qm.ReturnPage = ReturnPage;
        qm.SqlWhere = SqlWhere;
        qm.WorkPage = ReturnPage;



        bindData(qm);
    }
    protected void btnAll_Click(object sender, EventArgs e)
    {
        TableName = "RoomList";//表名
        SqlWhere = " 1=1 ";//过滤条件
        GetCountSql = "select count(id)  from RoomList where " + SqlWhere;
        SqlTable = "select *  from RoomList where " + SqlWhere + "  order by id desc ";
        ReturnPage = "RoomList.aspx";
        qm.TableName = TableName;
        qm.GetCountSql = GetCountSql;
        qm.GetTableSql = SqlTable;
        qm.ReturnPage = ReturnPage;
        qm.SqlWhere = SqlWhere;
        qm.WorkPage = ReturnPage;



        bindData(qm);
    }
}






